Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerOrderID (FK)(PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | CustomerOrderProductLineItem(DO_CTOLTM_PDT) |
CustomerOrderLineItemSequenceNumber (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. | IC_OR_LTM | LineNumber | smallint | CustomerOrderProductLineItem(DO_CTOLTM_PDT) |
CustomerOrderGroupID (FK)(PK) | A unique system assigned identifier for the group of line items from a Customer placed order, recording how the Customer wishes the StockItems that have been orderd are to be given to the Customer. | ID_CTORD_GRP | Identity | integer | CustomerOrderProductGroup(CO_CTORD_GRP) |
CustomerOrderProductAssignmentQuantity | The number of items from the OrderProductLineItem that are included in the OrderProductGroup. | QU_QTY | Quantity | DECIMAL(9,3) | |